EDA Report

Dataset info

Number of variables	24
Number of observations	688651
Missing cells	680435 (4.1%)
Duplicate rows	0 (0.0%)
Total size in memory	126.1 MiB
Average record size in memory	192.0 B

Variables types

Numeric	11
Categorical	11
Boolean	2
Date	0
URL	0
Text (Unique)	0
Rejected	0
Unsupported	0

Warnings

`ACCOUNT_CREATED_DATE` has 49909 (7.2%) missing values	Missing
`AMOUNT_USD` is highly skewed (γ1 = 654.2152316)	Skewed
`AMOUNT_USD` has 12126 (1.8%) zeros	Zeros
`BIRTH_YEAR` has 49909 (7.2%) missing values	Missing
`COUNTRY` has 49909 (7.2%) missing values	Missing
`FAILED_SIGN_IN_ATTEMPTS` is highly skewed (γ1 = 20.17361063)	Skewed
`FAILED_SIGN_IN_ATTEMPTS` has 635042 (92.2%) zeros	Zeros
`FAILED_SIGN_IN_ATTEMPTS` has 49909 (7.2%) missing values	Missing
`HAS_EMAIL` has 49909 (7.2%) missing values	Missing
`IS_FRAUDSTER` has 49909 (7.2%) missing values	Missing
`KYC` has 49909 (7.2%) missing values	Missing
`MERCH_COUNTRIES_USED` has 205596 (29.9%) missing values	Missing
`MERCHANT_COUNTRY` has a high cardinality: 345 distinct values	Warning
`PHONE_COUNTRY` has a high cardinality: 75 distinct values	Warning
`PHONE_COUNTRY` has 49909 (7.2%) missing values	Missing
`ROLLING_AVG` is highly skewed (γ1 = 75.16437548)	Skewed
`ROLLING_SUM` is highly skewed (γ1 = 51.60844599)	Skewed
`TERMS_VERSION` has 75567 (11.0%) missing values	Missing
`TIME_SINCE_LAST_TRANSACTION` is highly skewed (γ1 = 21.23906615)	Skewed
`TIME_SINCE_LAST_TRANSACTION` has 96868 (14.1%) zeros	Zeros
`USER_ID` has a high cardinality: 8021 distinct values	Warning

ACCOUNT_CREATED_DATE
Numeric

Distinct count	7749
Unique (%)	1.1%
Missing (%)	7.2%
Missing (n)	49909
Infinite (%)	0.0%
Infinite (n)	0

Mean	513.2905681
Minimum	0
Maximum	940.0294827
Zeros (%)	< 0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	96.35692163
Q1	291.7099367
Median	553.9698098
Q3	722.4251147
95-th percentile	857.0172394
Maximum	940.0294827
Range	940.0294827
Interquartile range	430.715178

Descriptive statistics

Standard deviation	245.9714487
Coef of variation	0.4792050819
Kurtosis	-1.113199889
Mean	513.2905681
MAD	212.660538
Skewness	-0.2851815096
Sum	327860244.1
Variance	60501.9536
Memory size	5.3 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
154.7391744	2725	0.4%
266.8504718	1888	0.3%
697.2446748	1856	0.3%
261.3337382	1802	0.3%
556.3107027	1725	0.3%
73.20995059	1559	0.2%
168.8945824	1513	0.2%
618.0554057	1496	0.2%
598.9775755	1448	0.2%
606.5665685	1441	0.2%
Other values (7738)	621289	90.2%
(Missing)	49909	7.2%

Minimum 5 values

Value	Count	Frequency (%)
0	148	< 0.1%
0.09821409722	165	< 0.1%
0.2424634259	7	< 0.1%
0.854335081	357	0.1%
0.8919533796	51	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
940.0294827	2	< 0.1%
940.0103932	2	< 0.1%
940.0069005	5	< 0.1%
939.8503398	2	< 0.1%
939.8478982	2	< 0.1%

AMOUNT_USD
Numeric

Distinct count	32381
Unique (%)	4.7%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	7130792.755
Minimum	0
Maximum	1.657094872e+12
Zeros (%)	1.8%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	66
Q1	515
Median	1475
Q3	5406
95-th percentile	33389
Maximum	1.657094872e+12
Range	1.657094872e+12
Interquartile range	4891

Descriptive statistics

Standard deviation	2248502125
Coef of variation	315.3228823
Kurtosis	455145.2689
Mean	7130792.755
MAD	14229081.08
Skewness	654.2152316
Sum	4.910627561e+12
Variance	5.055761804e+18
Memory size	5.3 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000000e+00 5.00000000e-01 1.50000000e+00 2.50000000e+00 4.50000000e+00 ... 1.90150601e+10 1.90524069e+10 1.93596944e+10 6.40808175e+10 1.65709487e+12], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1260	14434	2.1%
126	13815	2.0%
0	12126	1.8%
12606	10997	1.6%
111	10423	1.5%
6303	9065	1.3%
1112	8939	1.3%
2521	8182	1.2%
11129	7346	1.1%
2225	7005	1.0%
Other values (32371)	586319	85.1%

Minimum 5 values

Value	Count	Frequency (%)
0	12126	1.8%
1	1440	0.2%
2	506	0.1%
3	307	< 0.1%
4	237	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1.657094872e+12	1	< 0.1%
8.285474362e+11	1	< 0.1%
1.082269209e+11	1	< 0.1%
6.649063054e+10	1	< 0.1%
6.167100452e+10	1	< 0.1%

BIRTH_YEAR
Numeric

Distinct count	68
Unique (%)	< 0.1%
Missing (%)	7.2%
Missing (n)	49909
Infinite (%)	0.0%
Infinite (n)	0

Mean	1984.940629
Minimum	1927
Maximum	2000
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1927
5-th percentile	1965
Q1	1980
Median	1987
Q3	1992
95-th percentile	1997
Maximum	2000
Range	73
Interquartile range	12

Descriptive statistics

Standard deviation	9.887921541
Coef of variation	0.004981469671
Kurtosis	1.929580814
Mean	1984.940629
MAD	7.529709605
Skewness	-1.319251445
Sum	1267864947
Variance	97.7709924
Memory size	5.3 MiB

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1991	40150	5.8%
1990	37738	5.5%
1993	34553	5.0%
1989	34429	5.0%
1994	32689	4.7%
1988	31719	4.6%
1987	30006	4.4%
1992	29374	4.3%
1984	28115	4.1%
1986	26033	3.8%
Other values (57)	313936	45.6%
(Missing)	49909	7.2%

Minimum 5 values

Value	Count	Frequency (%)
1927	2	< 0.1%
1928	41	< 0.1%
1930	25	< 0.1%
1931	4	< 0.1%
1936	3	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
2000	1255	0.2%
1999	4160	0.6%
1998	12837	1.9%
1997	17311	2.5%
1996	17788	2.6%

COUNT
Numeric

Distinct count	2725
Unique (%)	0.4%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	210.452762
Minimum	1
Maximum	2725
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	5
Q1	36
Median	107
Q3	271
95-th percentile	769
Maximum	2725
Range	2724
Interquartile range	235

Descriptive statistics

Standard deviation	283.1574549
Coef of variation	1.345467991
Kurtosis	12.27753521
Mean	210.452762
MAD	190.1994128
Skewness	2.933569474
Sum	144928505
Variance	80178.14426
Memory size	5.3 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[1.0000e+00 1.5000e+00 2.5000e+00 3.5000e+00 5.5000e+00 ... 1.7255e+03 1.8565e+03 2.2935e+03 2.5715e+03 2.7250e+03], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1	8021	1.2%
2	7704	1.1%
3	6994	1.0%
4	6582	1.0%
5	6271	0.9%
6	6036	0.9%
7	5838	0.8%
8	5669	0.8%
9	5531	0.8%
10	5393	0.8%
Other values (2715)	624612	90.7%

Minimum 5 values

Value	Count	Frequency (%)
1	8021	1.2%
2	7704	1.1%
3	6994	1.0%
4	6582	1.0%
5	6271	0.9%

Maximum 5 values

Value	Count	Frequency (%)
2725	1	< 0.1%
2724	1	< 0.1%
2723	1	< 0.1%
2722	1	< 0.1%
2721	1	< 0.1%

COUNTRY
Categorical

Distinct count	45
Unique (%)	< 0.1%
Missing (%)	7.2%
Missing (n)	49909

GB	348946
FR	60041
LT	48154
Other values (41)	181601
(Missing)	49909

Toggle details

Common values
Composition

Value	Count	Frequency (%)
GB	348946	50.7%
FR	60041	8.7%
LT	48154	7.0%
IE	41723	6.1%
PL	25005	3.6%
ES	19311	2.8%
DE	8988	1.3%
PT	8137	1.2%
LV	7570	1.1%
RO	6903	1.0%
Other values (34)	63964	9.3%
(Missing)	49909	7.2%

Max length	4
Mean length	2.14494715
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

CURRENCIES_USED
Numeric

Distinct count	8
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1.26227799
Minimum	1
Maximum	8
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	1
Q3	1
95-th percentile	2
Maximum	8
Range	7
Interquartile range	0

Descriptive statistics

Standard deviation	0.6042684084
Coef of variation	0.4787126237
Kurtosis	12.23482698
Mean	1.26227799
MAD	0.4204873932
Skewness	2.976908195
Sum	869269
Variance	0.3651403093
Memory size	5.3 MiB

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
1	552027	80.2%
2	103538	15.0%
3	25004	3.6%
4	6194	0.9%
5	1287	0.2%
6	365	0.1%
7	135	< 0.1%
8	101	< 0.1%

Minimum 5 values

Value	Count	Frequency (%)
1	552027	80.2%
2	103538	15.0%
3	25004	3.6%
4	6194	0.9%
5	1287	0.2%

Maximum 5 values

Value	Count	Frequency (%)
8	101	< 0.1%
7	135	< 0.1%
6	365	0.1%
5	1287	0.2%
4	6194	0.9%

CURRENCY
Categorical

Distinct count	29
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

GBP	339091
EUR	264695
USD	31542
Other values (26)	53323

Toggle details

Common values
Composition

Value	Count	Frequency (%)
GBP	339091	49.2%
EUR	264695	38.4%
USD	31542	4.6%
PLN	22362	3.2%
RON	5837	0.8%
CHF	5761	0.8%
NOK	2602	0.4%
AUD	2110	0.3%
DKK	1711	0.2%
SEK	1579	0.2%
Other values (19)	11361	1.6%

Max length	3
Mean length	3
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

ENTRY_METHOD
Categorical

Distinct count	6
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

misc	227362
chip	183662
cont	160872
Other values (3)	116755

Toggle details

Common values
Composition

Value	Count	Frequency (%)
misc	227362	33.0%
chip	183662	26.7%
cont	160872	23.4%
manu	93952	13.6%
mags	22311	3.2%
mcon	492	0.1%

Max length	4
Mean length	4
Min length	4
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

FAILED_SIGN_IN_ATTEMPTS
Numeric

Distinct count	6
Unique (%)	< 0.1%
Missing (%)	7.2%
Missing (n)	49909
Infinite (%)	0.0%
Infinite (n)	0

Mean	0.009551587339
Minimum	0
Maximum	6
Zeros (%)	92.2%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
Median	0
Q3	0
95-th percentile	0
Maximum	6
Range	6
Interquartile range	0

Descriptive statistics

Standard deviation	0.1411770766
Coef of variation	14.78048324
Kurtosis	560.8706272
Mean	0.009551587339
MAD	0.01899251694
Skewness	20.17361063
Sum	6101
Variance	0.01993096696
Memory size	5.3 MiB

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	635042	92.2%
1	1762	0.3%
2	1715	0.2%
3	143	< 0.1%
6	80	< 0.1%
(Missing)	49909	7.2%

Minimum 5 values

Value	Count	Frequency (%)
0	635042	92.2%
1	1762	0.3%
2	1715	0.2%
3	143	< 0.1%
6	80	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
6	80	< 0.1%
3	143	< 0.1%
2	1715	0.2%
1	1762	0.3%
0	635042	92.2%

HAS_EMAIL
Boolean

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	7.2%
Missing (n)	49909

1	631879
0	6863
(Missing)	49909

Toggle details

Value	Count	Frequency (%)
1	631879	91.8%
0	6863	1.0%
(Missing)	49909	7.2%

IS_FRAUDSTER
Boolean

Distinct count	3
Unique (%)	< 0.1%
Missing (%)	7.2%
Missing (n)	49909

False	624828
True	13914
(Missing)	49909

Toggle details

Value	Count	Frequency (%)
False	624828	90.7%
True	13914	2.0%
(Missing)	49909	7.2%

KYC
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing (%)	7.2%
Missing (n)	49909

PASSED	629811
NONE	4879
PENDING	2283
(Missing)	49909

Toggle details

Common values
Composition

Value	Count	Frequency (%)
PASSED	629811	91.5%
NONE	4879	0.7%
PENDING	2283	0.3%
FAILED	1769	0.3%
(Missing)	49909	7.2%

Max length	7
Mean length	5.844198295
Min length	4
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

MERCH_COUNTRIES_USED
Numeric

Distinct count	48
Unique (%)	< 0.1%
Missing (%)	29.9%
Missing (n)	205596
Infinite (%)	0.0%
Infinite (n)	0

Mean	3.266474832
Minimum	1
Maximum	47
Zeros (%)	0.0%

Toggle details

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
Median	2
Q3	4
95-th percentile	10
Maximum	47
Range	46
Interquartile range	3

Descriptive statistics

Standard deviation	3.528709355
Coef of variation	1.080280589
Kurtosis	12.63899963
Mean	3.266474832
MAD	2.385861324
Skewness	2.915221279
Sum	1577887
Variance	12.45178971
Memory size	5.3 MiB

Histogram with fixed size bins (bins=48)

Value	Count	Frequency (%)
1	195596	28.4%
2	93177	13.5%
3	56033	8.1%
4	32505	4.7%
5	27073	3.9%
6	19061	2.8%
7	12516	1.8%
8	9644	1.4%
9	8416	1.2%
10	5472	0.8%
Other values (37)	23562	3.4%
(Missing)	205596	29.9%

Minimum 5 values

Value	Count	Frequency (%)
1	195596	28.4%
2	93177	13.5%
3	56033	8.1%
4	32505	4.7%
5	27073	3.9%

Maximum 5 values

Value	Count	Frequency (%)
47	1	< 0.1%
46	8	< 0.1%
45	1	< 0.1%
44	6	< 0.1%
43	12	< 0.1%

MERCHANT_COUNTRY
Categorical

Distinct count	345
Unique (%)	0.1%
Missing (%)	0.0%
Missing (n)	0

0	205596
GBR	146200
USA	46050
Other values (342)	290805

Toggle details

Common values
Composition

Value	Count	Frequency (%)
0	205596	29.9%
GBR	146200	21.2%
USA	46050	6.7%
FRA	28980	4.2%
IRL	26196	3.8%
LTU	25597	3.7%
ESP	23329	3.4%
NLD	18532	2.7%
AUS	10088	1.5%
POL	10028	1.5%
Other values (335)	148055	21.5%

Max length	3
Mean length	2.402250196
Min length	1
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

PHONE_COUNTRY
Categorical

Distinct count	75
Unique (%)	< 0.1%
Missing (%)	7.2%
Missing (n)	49909

GB\|\|JE\|\|IM\|\|GG	328346
FR	63293
LT	48740
Other values (71)	198363
(Missing)	49909

Toggle details

Common values
Composition

Value	Count	Frequency (%)
GB\|\|JE\|\|IM\|\|GG	328346	47.7%
FR	63293	9.2%
LT	48740	7.1%
IE	41184	6.0%
PL	26674	3.9%
ES	17325	2.5%
DE	11402	1.7%
PT	8112	1.2%
RO	8016	1.2%
LV	7865	1.1%
Other values (64)	77785	11.3%
(Missing)	49909	7.2%

Max length	14
Mean length	7.983416854
Min length	2
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	True

ROLLING_AVG
Numeric

Distinct count	539512
Unique (%)	78.3%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	5180059.39
Minimum	0
Maximum	2.716549277e+10
Zeros (%)	< 0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	1000
Q1	3091.45
Median	5661.06
Q3	10313.355
95-th percentile	44495.085
Maximum	2.716549277e+10
Range	2.716549277e+10
Interquartile range	7221.905

Descriptive statistics

Standard deviation	221151348.9
Coef of variation	42.69282111
Kurtosis	6617.474948
Mean	5180059.39
MAD	10129257.09
Skewness	75.16437548
Sum	3.567253079e+12
Variance	4.890791912e+16
Memory size	5.3 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000000e+00 1.65000000e-01 3.66500000e+00 4.50000000e+00 9.75000000e+00 ... 4.33386343e+09 4.57033444e+09 9.71912295e+09 1.54151738e+10 2.71654928e+10], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
126	4401	0.6%
111	3600	0.5%
693	1781	0.3%
611.5	1127	0.2%
25	620	0.1%
882	470	0.1%
1260	356	0.1%
504	352	0.1%
3214.5	307	< 0.1%
2837.5	274	< 0.1%
Other values (539502)	675363	98.1%

Minimum 5 values

Value	Count	Frequency (%)
0	169	< 0.1%
0.33	1	< 0.1%
0.5	1	< 0.1%
0.67	1	< 0.1%
1	8	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
2.716549277e+10	1	< 0.1%
2.672733972e+10	1	< 0.1%
2.630309676e+10	1	< 0.1%
2.589211136e+10	1	< 0.1%
2.549377125e+10	1	< 0.1%

ROLLING_SUM
Numeric

Distinct count	565098
Unique (%)	82.1%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	848903689.5
Minimum	0
Maximum	1.657096214e+12
Zeros (%)	< 0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	12518
Q1	196310.5
Median	662280
Q3	1840874
95-th percentile	8690098
Maximum	1.657096214e+12
Range	1.657096214e+12
Interquartile range	1644563.5

Descriptive statistics

Standard deviation	2.566105873e+10
Coef of variation	30.22846884
Kurtosis	3026.587552
Mean	848903689.5
MAD	1654299448
Skewness	51.60844599
Sum	5.845983747e+14
Variance	6.584899349e+20
Memory size	5.3 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.00000000e+00 5.00000000e-01 3.00000000e+00 4.50000000e+00 9.50000000e+00 ... 1.65709521e+12 1.65709533e+12 1.65709589e+12 1.65709614e+12 1.65709621e+12], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
126	3302	0.5%
111	2430	0.4%
1386	1670	0.2%
1223	1051	0.2%
252	572	0.1%
222	524	0.1%
25	483	0.1%
2646	461	0.1%
1512	356	0.1%
1260	316	< 0.1%
Other values (565088)	677486	98.4%

Minimum 5 values

Value	Count	Frequency (%)
0	169	< 0.1%
1	9	< 0.1%
2	4	< 0.1%
4	39	< 0.1%
5	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1.657096214e+12	1	< 0.1%
1.657096211e+12	1	< 0.1%
1.657096206e+12	1	< 0.1%
1.657096205e+12	1	< 0.1%
1.657096205e+12	1	< 0.1%

SOURCE
Categorical

Distinct count	11
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

GAIA	483831
HERA	116081
INTERNAL	56407
Other values (8)	32332

Toggle details

Common values
Composition

Value	Count	Frequency (%)
GAIA	483831	70.3%
HERA	116081	16.9%
INTERNAL	56407	8.2%
MINOS	11056	1.6%
LETO	6935	1.0%
CRONUS	6139	0.9%
NYX	5178	0.8%
OPHION	1278	0.2%
LIMOS	961	0.1%
APOLLO	784	0.1%

Max length	8
Mean length	4.361387699
Min length	3
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

TERMS_VERSION
Categorical

Distinct count	8
Unique (%)	< 0.1%
Missing (%)	11.0%
Missing (n)	75567

2018-09-20	298644
2018-05-25	213103
2018-03-20	78458
Other values (4)	22879
(Missing)	75567

Toggle details

Common values
Composition

Value	Count	Frequency (%)
2018-09-20	298644	43.4%
2018-05-25	213103	30.9%
2018-03-20	78458	11.4%
2018-01-01	7345	1.1%
2017-01-16	6844	1.0%
2018-01-13	5585	0.8%
2017-02-02	3105	0.5%
(Missing)	75567	11.0%

Max length	10
Mean length	9.341608449
Min length	4
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

TIME_SINCE_LAST_TRANSACTION
Numeric

Distinct count	34188
Unique (%)	5.0%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	3202.712086
Minimum	0
Maximum	1514745
Zeros (%)	14.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	0
Q1	10
Median	199
Q3	1272
95-th percentile	10377
Maximum	1514745
Range	1514745
Interquartile range	1262

Descriptive statistics

Standard deviation	19712.5374
Coef of variation	6.15495145
Kurtosis	690.4626931
Mean	3202.712086
MAD	4763.704205
Skewness	21.23906615
Sum	2205550881
Variance	388584130.8
Memory size	5.3 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[0.000000e+00 5.000000e-01 1.500000e+00 2.500000e+00 3.500000e+00 ... 4.911015e+05 5.938740e+05 8.208985e+05 1.056699e+06 1.514745e+06], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
0	96868	14.1%
1	21593	3.1%
2	12015	1.7%
3	8475	1.2%
4	6797	1.0%
5	5660	0.8%
6	4855	0.7%
7	4414	0.6%
8	4020	0.6%
9	3932	0.6%
Other values (34178)	520022	75.5%

Minimum 5 values

Value	Count	Frequency (%)
0	96868	14.1%
1	21593	3.1%
2	12015	1.7%
3	8475	1.2%
4	6797	1.0%

Maximum 5 values

Value	Count	Frequency (%)
1514745	1	< 0.1%
1283293	1	< 0.1%
1151261	1	< 0.1%
1139724	1	< 0.1%
1061079	1	< 0.1%

TRANSACTION_DATE
Numeric

Distinct count	688640
Unique (%)	> 99.9%
Missing (%)	0.0%
Missing (n)	0
Infinite (%)	0.0%
Infinite (n)	0

Mean	1016.787528
Minimum	0
Maximum	1246.064319
Zeros (%)	< 0.1%

Toggle details

Quantile statistics

Minimum	0
5-th percentile	536.7981409
Q1	908.4072873
Median	1095.676915
Q3	1186.924301
95-th percentile	1235.155439
Maximum	1246.064319
Range	1246.064319
Interquartile range	278.5170136

Descriptive statistics

Standard deviation	221.8661987
Coef of variation	0.2182031079
Kurtosis	1.150564108
Mean	1016.787528
MAD	175.7797174
Skewness	-1.306616991
Sum	700211747.9
Variance	49224.61012
Memory size	5.3 MiB

Histogram with fixed size bins (bins=50)

Histogram with variable size bins (bins=[ 0. 127.56242037 142.79027532 149.95207432 159.89678037 ... 1245.59855462 1245.70085707 1245.75656036 1245.88612014 1246.06431891], "bayesian blocks" binning strategy used)

Value	Count	Frequency (%)
1179.053614	2	< 0.1%
1227.960335	2	< 0.1%
1187.160424	2	< 0.1%
1222.209915	2	< 0.1%
1146.055195	2	< 0.1%
1158.768694	2	< 0.1%
1168.202019	2	< 0.1%
1172.837944	2	< 0.1%
1222.910702	2	< 0.1%
406.8574973	2	< 0.1%
Other values (688630)	688631	> 99.9%

Minimum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1.984719109	1	< 0.1%
56.34827697	1	< 0.1%
56.35596095	1	< 0.1%
56.37551001	1	< 0.1%

Maximum 5 values

Value	Count	Frequency (%)
1246.064319	1	< 0.1%
1246.064063	1	< 0.1%
1246.06386	1	< 0.1%
1246.063738	1	< 0.1%
1246.063441	1	< 0.1%

TRANSACTION_STATE
Categorical

Distinct count	7
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

COMPLETED	584507
DECLINED	45635
REVERTED	38663
Other values (4)	19846

Toggle details

Common values
Composition

Value	Count	Frequency (%)
COMPLETED	584507	84.9%
DECLINED	45635	6.6%
REVERTED	38663	5.6%
FAILED	16763	2.4%
PENDING	2477	0.4%
CANCELLED	515	0.1%
RECORDED	91	< 0.1%

Max length	9
Mean length	8.797238369
Min length	6
Contains chars	True
Contains digits	False
Contains spaces	False
Contains non-words	False

TYPE
Categorical

Distinct count	5
Unique (%)	< 0.1%
Missing (%)	0.0%
Missing (n)	0

CARD_PAYMENT	436570
TOPUP	132561
P2P	56338
Other values (2)	63182

Toggle details

Common values
Composition

Value	Count	Frequency (%)
CARD_PAYMENT	436570	63.4%
TOPUP	132561	19.2%
P2P	56338	8.2%
ATM	47324	6.9%
BANK_TRANSFER	15858	2.3%

Max length	13
Mean length	9.320809815
Min length	3
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	False

USER_ID
Categorical

Distinct count	8021
Unique (%)	1.2%
Missing (%)	0.0%
Missing (n)	0

84e22e7f-f2ab-413c-969a-667c78d8885c	2725
26e8432c-5fdb-4b67-82e6-18f341d511a1	2571
f54baeeb-7282-4d23-9bb7-e8396ce1b159	2293
Other values (8018)	681062

Toggle details

Common values
Composition

Value	Count	Frequency (%)
84e22e7f-f2ab-413c-969a-667c78d8885c	2725	0.4%
26e8432c-5fdb-4b67-82e6-18f341d511a1	2571	0.4%
f54baeeb-7282-4d23-9bb7-e8396ce1b159	2293	0.3%
8dd8b009-bcc7-4b14-a26f-c87c232383f4	1888	0.3%
4366241f-0cac-4978-a4a3-27f38abc174a	1856	0.3%
d1bc3cd6-154e-479f-8957-a69cdf414462	1844	0.3%
0314aa87-cf7e-43f2-86c6-ae36dfa4d9b0	1802	0.3%
dc78fbc4-c936-45d3-a813-e2477ac6d74b	1725	0.3%
0fe472c9-cf3e-4e43-90f3-a0cfb6a4f1f0	1686	0.2%
6cae3eb6-515c-4811-8b51-32fb2e95da28	1559	0.2%
Other values (8011)	668702	97.1%

Max length	36
Mean length	36
Min length	36
Contains chars	True
Contains digits	True
Contains spaces	False
Contains non-words	True

First rows

	ACCOUNT_CREATED_DATE	AMOUNT_USD	BIRTH_YEAR	COUNT	COUNTRY	CURRENCIES_USED	CURRENCY	ENTRY_METHOD	HAS_EMAIL	IS_FRAUDSTER	KYC	MERCH_COUNTRIES_USED	MERCHANT_COUNTRY	PHONE_COUNTRY	ROLLING_AVG	ROLLING_SUM	SOURCE	TERMS_VERSION	TIME_SINCE_LAST_TRANSACTION	TRANSACTION_DATE	TRANSACTION_STATE	TYPE	USER_ID
0	789.008585	14	1989.0	1	DK	1	DKK	misc	1.0	False	PASSED	NaN	0	DK	14.00	14.0	HERA	2018-03-20	0.0	1100.318753	REVERTED	TOPUP	000e88bb-d302-4fdc-b757-2b1a2c33e7d6
1	789.008585	1490	1989.0	2	DK	1	DKK	misc	1.0	False	PASSED	NaN	0	DK	752.00	1504.0	HERA	2018-03-20	0.0	1100.318955	COMPLETED	TOPUP	000e88bb-d302-4fdc-b757-2b1a2c33e7d6
2	789.008585	7451	1989.0	3	DK	1	DKK	misc	1.0	False	PASSED	NaN	0	DK	2985.00	8955.0	HERA	2018-03-20	62886.0	1143.990318	COMPLETED	TOPUP	000e88bb-d302-4fdc-b757-2b1a2c33e7d6
3	789.008585	8880	1989.0	4	DK	1	DKK	misc	1.0	False	PASSED	NaN	0	DK	4458.75	17835.0	CRONUS	2018-03-20	5.0	1143.994202	COMPLETED	BANK_TRANSFER	000e88bb-d302-4fdc-b757-2b1a2c33e7d6
4	789.008585	7451	1989.0	5	DK	1	DKK	misc	1.0	False	PASSED	NaN	0	DK	5057.20	25286.0	HERA	2018-03-20	17633.0	1156.239779	COMPLETED	TOPUP	000e88bb-d302-4fdc-b757-2b1a2c33e7d6
5	789.008585	5216	1989.0	6	DK	1	DKK	misc	1.0	False	PASSED	NaN	0	DK	5083.67	30502.0	INTERNAL	2018-03-20	1.0	1156.240639	COMPLETED	P2P	000e88bb-d302-4fdc-b757-2b1a2c33e7d6
6	789.008585	559	1989.0	7	DK	1	DKK	cont	1.0	False	PASSED	1.0	FRA	DK	4437.29	31061.0	GAIA	2018-03-20	55777.0	1194.975126	REVERTED	CARD_PAYMENT	000e88bb-d302-4fdc-b757-2b1a2c33e7d6
7	789.008585	559	1989.0	8	DK	1	DKK	cont	1.0	False	PASSED	1.0	FRA	DK	3952.50	31620.0	GAIA	2018-03-20	2.0	1194.977094	REVERTED	CARD_PAYMENT	000e88bb-d302-4fdc-b757-2b1a2c33e7d6
8	789.008585	89	1989.0	9	DK	1	DKK	cont	1.0	False	PASSED	1.0	FRA	DK	3523.22	31709.0	GAIA	2018-03-20	247.0	1195.148885	COMPLETED	CARD_PAYMENT	000e88bb-d302-4fdc-b757-2b1a2c33e7d6
9	789.008585	67	1989.0	10	DK	1	DKK	cont	1.0	False	PASSED	1.0	FRA	DK	3177.60	31776.0	GAIA	2018-03-20	4.0	1195.151880	COMPLETED	CARD_PAYMENT	000e88bb-d302-4fdc-b757-2b1a2c33e7d6

Last rows

	ACCOUNT_CREATED_DATE	AMOUNT_USD	BIRTH_YEAR	COUNT	COUNTRY	CURRENCIES_USED	CURRENCY	ENTRY_METHOD	HAS_EMAIL	IS_FRAUDSTER	KYC	MERCH_COUNTRIES_USED	MERCHANT_COUNTRY	PHONE_COUNTRY	ROLLING_AVG	ROLLING_SUM	SOURCE	TERMS_VERSION	TIME_SINCE_LAST_TRANSACTION	TRANSACTION_DATE	TRANSACTION_STATE	TYPE	USER_ID
688641	439.026435	6	1986.0	50	FR	1	EUR	misc	1.0	False	PASSED	NaN	0	FR	3182.76	159138.0	LETO	2018-09-20	0.0	1162.760362	COMPLETED	TOPUP	ffd5d3f9-2f87-4f38-8e6d-f008ac79bb33
688642	439.026435	44613	1986.0	51	FR	1	EUR	misc	1.0	False	PASSED	NaN	0	FR	3995.12	203751.0	LETO	2018-09-20	22111.0	1178.115361	COMPLETED	TOPUP	ffd5d3f9-2f87-4f38-8e6d-f008ac79bb33
688643	439.026435	4256	1986.0	52	FR	1	EUR	chip	1.0	False	PASSED	1.0	FRA	FR	4000.13	208007.0	GAIA	2018-09-20	3259.0	1180.378689	COMPLETED	CARD_PAYMENT	ffd5d3f9-2f87-4f38-8e6d-f008ac79bb33
688644	439.026435	3305	1986.0	53	FR	1	EUR	chip	1.0	False	PASSED	1.0	FRA	FR	3987.02	211312.0	GAIA	2018-09-20	3492.0	1182.803769	COMPLETED	CARD_PAYMENT	ffd5d3f9-2f87-4f38-8e6d-f008ac79bb33
688645	439.026435	1112	1986.0	54	FR	1	EUR	manu	1.0	False	PASSED	1.0	FRA	FR	3933.78	212424.0	GAIA	2018-09-20	8833.0	1188.937927	COMPLETED	CARD_PAYMENT	ffd5d3f9-2f87-4f38-8e6d-f008ac79bb33
688646	439.026435	8665	1986.0	55	FR	1	EUR	manu	1.0	False	PASSED	4.0	GBR	FR	4019.80	221089.0	GAIA	2018-09-20	48856.0	1222.865922	COMPLETED	CARD_PAYMENT	ffd5d3f9-2f87-4f38-8e6d-f008ac79bb33
688647	439.026435	8665	1986.0	56	FR	1	EUR	manu	1.0	False	PASSED	4.0	GBR	FR	4102.75	229754.0	GAIA	2018-09-20	0.0	1222.866171	DECLINED	CARD_PAYMENT	ffd5d3f9-2f87-4f38-8e6d-f008ac79bb33
688648	439.026435	2003	1986.0	57	FR	1	EUR	manu	1.0	False	PASSED	1.0	FRA	FR	4065.91	231757.0	GAIA	2018-09-20	25834.0	1240.807053	COMPLETED	CARD_PAYMENT	ffd5d3f9-2f87-4f38-8e6d-f008ac79bb33
688649	929.089708	23	1963.0	1	RO	1	RON	misc	1.0	False	PASSED	NaN	0	RO	23.00	23.0	HERA	2018-05-25	0.0	1236.891665	REVERTED	TOPUP	fff200b0-5204-4f7d-86eb-3bb5654b4636
688650	929.089708	2341	1963.0	2	RO	1	RON	misc	1.0	False	PASSED	NaN	0	RO	1182.00	2364.0	HERA	2018-05-25	0.0	1236.891972	COMPLETED	TOPUP	fff200b0-5204-4f7d-86eb-3bb5654b4636

Overview

Variables

Correlations

Missing values

Sample

First rows

Last rows